Overview
Brought to you by YData
Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 87396 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 20.8 MiB |
| Average record size in memory | 249.0 B |
Variable types
| Categorical | 15 |
|---|---|
| Numeric | 13 |
| Text | 3 |
| DateTime | 1 |
arrival_date_month is highly overall correlated with arrival_date_week_number | High correlation |
arrival_date_week_number is highly overall correlated with arrival_date_month | High correlation |
assigned_room_type is highly overall correlated with reserved_room_type | High correlation |
distribution_channel is highly overall correlated with market_segment | High correlation |
is_canceled is highly overall correlated with reservation_status | High correlation |
market_segment is highly overall correlated with distribution_channel | High correlation |
reservation_status is highly overall correlated with is_canceled | High correlation |
reserved_room_type is highly overall correlated with assigned_room_type | High correlation |
babies is highly imbalanced (96.3%) | Imbalance |
meal is highly imbalanced (55.0%) | Imbalance |
distribution_channel is highly imbalanced (59.8%) | Imbalance |
is_repeated_guest is highly imbalanced (76.2%) | Imbalance |
reserved_room_type is highly imbalanced (51.3%) | Imbalance |
deposit_type is highly imbalanced (93.3%) | Imbalance |
customer_type is highly imbalanced (58.1%) | Imbalance |
required_car_parking_spaces is highly imbalanced (82.0%) | Imbalance |
previous_cancellations is highly skewed (γ1 = 34.32374385) | Skewed |
previous_bookings_not_canceled is highly skewed (γ1 = 20.45972514) | Skewed |
lead_time has 5978 (6.8%) zeros | Zeros |
stays_in_weekend_nights has 35151 (40.2%) zeros | Zeros |
stays_in_week_nights has 6175 (7.1%) zeros | Zeros |
children has 79028 (90.4%) zeros | Zeros |
previous_cancellations has 85711 (98.1%) zeros | Zeros |
previous_bookings_not_canceled has 83851 (95.9%) zeros | Zeros |
booking_changes has 71494 (81.8%) zeros | Zeros |
days_in_waiting_list has 86536 (99.0%) zeros | Zeros |
adr has 1778 (2.0%) zeros | Zeros |
total_of_special_requests has 43894 (50.2%) zeros | Zeros |
Reproduction
| Analysis started | 2025-04-04 06:46:50.456718 |
|---|---|
| Analysis finished | 2025-04-04 06:47:20.581835 |
| Duration | 30.13 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
hotel
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| City Hotel | |
|---|---|
| Resort Hotel |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 10.777335 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Resort Hotel |
|---|---|
| 2nd row | Resort Hotel |
| 3rd row | Resort Hotel |
| 4th row | Resort Hotel |
| 5th row | Resort Hotel |
Common Values
| Value | Count | Frequency (%) |
| City Hotel | 53428 | |
| Resort Hotel | 33968 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| hotel | 87396 | |
| city | 53428 | |
| resort | 33968 | 19.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 174792 | |
| o | 121364 | |
| e | 121364 | |
| 87396 | ||
| H | 87396 | |
| l | 87396 | |
| C | 53428 | 5.7% |
| i | 53428 | 5.7% |
| y | 53428 | 5.7% |
| R | 33968 | 3.6% |
| Other values (2) | 67936 | 7.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 941896 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 174792 | |
| o | 121364 | |
| e | 121364 | |
| 87396 | ||
| H | 87396 | |
| l | 87396 | |
| C | 53428 | 5.7% |
| i | 53428 | 5.7% |
| y | 53428 | 5.7% |
| R | 33968 | 3.6% |
| Other values (2) | 67936 | 7.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 941896 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 174792 | |
| o | 121364 | |
| e | 121364 | |
| 87396 | ||
| H | 87396 | |
| l | 87396 | |
| C | 53428 | 5.7% |
| i | 53428 | 5.7% |
| y | 53428 | 5.7% |
| R | 33968 | 3.6% |
| Other values (2) | 67936 | 7.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 941896 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 174792 | |
| o | 121364 | |
| e | 121364 | |
| 87396 | ||
| H | 87396 | |
| l | 87396 | |
| C | 53428 | 5.7% |
| i | 53428 | 5.7% |
| y | 53428 | 5.7% |
| R | 33968 | 3.6% |
| Other values (2) | 67936 | 7.2% |
is_canceled
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 63371 | |
| 1 | 24025 | 27.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 63371 | |
| 1 | 24025 | 27.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 63371 | |
| 1 | 24025 | 27.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 63371 | |
| 1 | 24025 | 27.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 63371 | |
| 1 | 24025 | 27.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 63371 | |
| 1 | 24025 | 27.5% |
lead_time
Real number (ℝ)
Zeros
| Distinct | 479 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 79.891368 |
| Minimum | 0 |
|---|---|
| Maximum | 737 |
| Zeros | 5978 |
| Zeros (%) | 6.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 682.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 11 |
| median | 49 |
| Q3 | 125 |
| 95-th percentile | 256 |
| Maximum | 737 |
| Range | 737 |
| Interquartile range (IQR) | 114 |
Descriptive statistics
| Standard deviation | 86.052325 |
|---|---|
| Coefficient of variation (CV) | 1.0771167 |
| Kurtosis | 2.1263433 |
| Mean | 79.891368 |
| Median Absolute Deviation (MAD) | 44 |
| Skewness | 1.4317738 |
| Sum | 6982186 |
| Variance | 7405.0027 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 5978 | 6.8% |
| 1 | 3216 | 3.7% |
| 2 | 1927 | 2.2% |
| 3 | 1704 | 1.9% |
| 4 | 1570 | 1.8% |
| 5 | 1418 | 1.6% |
| 6 | 1300 | 1.5% |
| 7 | 1191 | 1.4% |
| 8 | 1019 | 1.2% |
| 12 | 915 | 1.0% |
| Other values (469) | 67158 |
| Value | Count | Frequency (%) |
| 0 | 5978 | |
| 1 | 3216 | |
| 2 | 1927 | 2.2% |
| 3 | 1704 | 1.9% |
| 4 | 1570 | 1.8% |
| 5 | 1418 | 1.6% |
| 6 | 1300 | 1.5% |
| 7 | 1191 | 1.4% |
| 8 | 1019 | 1.2% |
| 9 | 900 | 1.0% |
| Value | Count | Frequency (%) |
| 737 | 1 | |
| 709 | 1 | |
| 629 | 2 | |
| 626 | 1 | |
| 622 | 2 | |
| 615 | 2 | |
| 608 | 2 | |
| 605 | 1 | |
| 601 | 2 | |
| 594 | 2 |
arrival_date_year
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| 2016 | |
|---|---|
| 2017 | |
| 2015 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2015 |
|---|---|
| 2nd row | 2015 |
| 3rd row | 2015 |
| 4th row | 2015 |
| 5th row | 2015 |
Common Values
| Value | Count | Frequency (%) |
| 2016 | 42391 | |
| 2017 | 31692 | |
| 2015 | 13313 | 15.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2016 | 42391 | |
| 2017 | 31692 | |
| 2015 | 13313 | 15.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 87396 | |
| 0 | 87396 | |
| 1 | 87396 | |
| 6 | 42391 | |
| 7 | 31692 | 9.1% |
| 5 | 13313 | 3.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 349584 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 87396 | |
| 0 | 87396 | |
| 1 | 87396 | |
| 6 | 42391 | |
| 7 | 31692 | 9.1% |
| 5 | 13313 | 3.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 349584 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 87396 | |
| 0 | 87396 | |
| 1 | 87396 | |
| 6 | 42391 | |
| 7 | 31692 | 9.1% |
| 5 | 13313 | 3.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 349584 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 87396 | |
| 0 | 87396 | |
| 1 | 87396 | |
| 6 | 42391 | |
| 7 | 31692 | 9.1% |
| 5 | 13313 | 3.8% |
arrival_date_month
Categorical
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 85.9 KiB |
| August | |
|---|---|
| July | |
| May | |
| April | |
| June | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 5.8628656 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | July |
|---|---|
| 2nd row | July |
| 3rd row | July |
| 4th row | July |
| 5th row | July |
Common Values
| Value | Count | Frequency (%) |
| August | 11257 | |
| July | 10057 | |
| May | 8355 | |
| April | 7908 | |
| June | 7765 | |
| March | 7513 | |
| October | 6934 | |
| September | 6690 | |
| February | 6098 | |
| December | 5131 | |
| Other values (2) | 9688 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| august | 11257 | |
| july | 10057 | |
| may | 8355 | |
| april | 7908 | |
| june | 7765 | |
| march | 7513 | |
| october | 6934 | |
| september | 6690 | |
| february | 6098 | |
| december | 5131 | |
| Other values (2) | 9688 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 66250 | |
| r | 56060 | 10.9% |
| u | 51127 | 10.0% |
| a | 31352 | 6.1% |
| b | 29848 | 5.8% |
| y | 29203 | 5.7% |
| t | 24881 | 4.9% |
| J | 22515 | 4.4% |
| c | 19578 | 3.8% |
| A | 19165 | 3.7% |
| Other values (16) | 162412 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 512391 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 66250 | |
| r | 56060 | 10.9% |
| u | 51127 | 10.0% |
| a | 31352 | 6.1% |
| b | 29848 | 5.8% |
| y | 29203 | 5.7% |
| t | 24881 | 4.9% |
| J | 22515 | 4.4% |
| c | 19578 | 3.8% |
| A | 19165 | 3.7% |
| Other values (16) | 162412 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 512391 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 66250 | |
| r | 56060 | 10.9% |
| u | 51127 | 10.0% |
| a | 31352 | 6.1% |
| b | 29848 | 5.8% |
| y | 29203 | 5.7% |
| t | 24881 | 4.9% |
| J | 22515 | 4.4% |
| c | 19578 | 3.8% |
| A | 19165 | 3.7% |
| Other values (16) | 162412 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 512391 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 66250 | |
| r | 56060 | 10.9% |
| u | 51127 | 10.0% |
| a | 31352 | 6.1% |
| b | 29848 | 5.8% |
| y | 29203 | 5.7% |
| t | 24881 | 4.9% |
| J | 22515 | 4.4% |
| c | 19578 | 3.8% |
| A | 19165 | 3.7% |
| Other values (16) | 162412 |
arrival_date_week_number
Real number (ℝ)
High correlation
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.838334 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 682.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 16 |
| median | 27 |
| Q3 | 37 |
| 95-th percentile | 49 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 21 |
Descriptive statistics
| Standard deviation | 13.674572 |
|---|---|
| Coefficient of variation (CV) | 0.50951642 |
| Kurtosis | -0.95260753 |
| Mean | 26.838334 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 0.022503631 |
| Sum | 2345563 |
| Variance | 186.99391 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 33 | 2793 | 3.2% |
| 34 | 2491 | 2.9% |
| 32 | 2449 | 2.8% |
| 28 | 2344 | 2.7% |
| 30 | 2335 | 2.7% |
| 31 | 2287 | 2.6% |
| 29 | 2197 | 2.5% |
| 27 | 2166 | 2.5% |
| 35 | 2105 | 2.4% |
| 18 | 2089 | 2.4% |
| Other values (43) | 64140 |
| Value | Count | Frequency (%) |
| 1 | 862 | |
| 2 | 945 | |
| 3 | 1050 | |
| 4 | 1125 | |
| 5 | 1101 | |
| 6 | 1299 | |
| 7 | 1630 | |
| 8 | 1525 | |
| 9 | 1579 | |
| 10 | 1630 |
| Value | Count | Frequency (%) |
| 53 | 1423 | |
| 52 | 1061 | |
| 51 | 786 | |
| 50 | 1053 | |
| 49 | 1170 | |
| 48 | 1199 | |
| 47 | 1289 | |
| 46 | 1141 | |
| 45 | 1315 | |
| 44 | 1550 |
arrival_date_day_of_month
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.815541 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 682.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.8351464 |
|---|---|
| Coefficient of variation (CV) | 0.55863701 |
| Kurtosis | -1.1962139 |
| Mean | 15.815541 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.00030825172 |
| Sum | 1382215 |
| Variance | 78.059813 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 17 | 3020 | 3.5% |
| 2 | 3016 | 3.5% |
| 26 | 3000 | 3.4% |
| 5 | 2980 | 3.4% |
| 16 | 2959 | 3.4% |
| 19 | 2949 | 3.4% |
| 12 | 2929 | 3.4% |
| 28 | 2929 | 3.4% |
| 18 | 2924 | 3.3% |
| 11 | 2915 | 3.3% |
| Other values (21) | 57775 |
| Value | Count | Frequency (%) |
| 1 | 2770 | |
| 2 | 3016 | |
| 3 | 2834 | |
| 4 | 2801 | |
| 5 | 2980 | |
| 6 | 2805 | |
| 7 | 2704 | |
| 8 | 2809 | |
| 9 | 2878 | |
| 10 | 2785 |
| Value | Count | Frequency (%) |
| 31 | 1733 | |
| 30 | 2772 | |
| 29 | 2880 | |
| 28 | 2929 | |
| 27 | 2902 | |
| 26 | 3000 | |
| 25 | 2838 | |
| 24 | 2775 | |
| 23 | 2776 | |
| 22 | 2601 |
stays_in_weekend_nights
Real number (ℝ)
Zeros
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0052634 |
| Minimum | 0 |
|---|---|
| Maximum | 19 |
| Zeros | 35151 |
| Zeros (%) | 40.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 682.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 19 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.0319213 |
|---|---|
| Coefficient of variation (CV) | 1.0265183 |
| Kurtosis | 7.9934904 |
| Mean | 1.0052634 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.4116374 |
| Sum | 87856 |
| Variance | 1.0648616 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) |
| 0 | 35151 | |
| 2 | 26414 | |
| 1 | 22657 | |
| 4 | 1734 | 2.0% |
| 3 | 1150 | 1.3% |
| 6 | 113 | 0.1% |
| 5 | 70 | 0.1% |
| 8 | 60 | 0.1% |
| 7 | 15 | < 0.1% |
| 9 | 10 | < 0.1% |
| Other values (7) | 22 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 35151 | |
| 1 | 22657 | |
| 2 | 26414 | |
| 3 | 1150 | 1.3% |
| 4 | 1734 | 2.0% |
| 5 | 70 | 0.1% |
| 6 | 113 | 0.1% |
| 7 | 15 | < 0.1% |
| 8 | 60 | 0.1% |
| 9 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 19 | 1 | < 0.1% |
| 18 | 1 | < 0.1% |
| 16 | 3 | < 0.1% |
| 14 | 2 | < 0.1% |
| 13 | 3 | < 0.1% |
| 12 | 5 | < 0.1% |
| 10 | 7 | < 0.1% |
| 9 | 10 | < 0.1% |
| 8 | 60 | |
| 7 | 15 | < 0.1% |
stays_in_week_nights
Real number (ℝ)
Zeros
| Distinct | 35 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.6253948 |
| Minimum | 0 |
|---|---|
| Maximum | 50 |
| Zeros | 6175 |
| Zeros (%) | 7.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 682.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.0535839 |
|---|---|
| Coefficient of variation (CV) | 0.78220005 |
| Kurtosis | 22.103258 |
| Mean | 2.6253948 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.6913209 |
| Sum | 229449 |
| Variance | 4.2172069 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=35)
| Value | Count | Frequency (%) |
| 1 | 22191 | |
| 2 | 20744 | |
| 3 | 16259 | |
| 5 | 9663 | |
| 4 | 7874 | 9.0% |
| 0 | 6175 | 7.1% |
| 6 | 1379 | 1.6% |
| 10 | 972 | 1.1% |
| 7 | 967 | 1.1% |
| 8 | 613 | 0.7% |
| Other values (25) | 559 | 0.6% |
| Value | Count | Frequency (%) |
| 0 | 6175 | 7.1% |
| 1 | 22191 | |
| 2 | 20744 | |
| 3 | 16259 | |
| 4 | 7874 | 9.0% |
| 5 | 9663 | |
| 6 | 1379 | 1.6% |
| 7 | 967 | 1.1% |
| 8 | 613 | 0.7% |
| 9 | 219 | 0.3% |
| Value | Count | Frequency (%) |
| 50 | 1 | < 0.1% |
| 42 | 1 | < 0.1% |
| 41 | 1 | < 0.1% |
| 40 | 2 | < 0.1% |
| 35 | 1 | < 0.1% |
| 34 | 1 | < 0.1% |
| 33 | 1 | < 0.1% |
| 32 | 1 | < 0.1% |
| 30 | 5 | |
| 26 | 1 | < 0.1% |
adults
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8757952 |
| Minimum | 0 |
|---|---|
| Maximum | 55 |
| Zeros | 385 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 682.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 55 |
| Range | 55 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.62650021 |
|---|---|
| Coefficient of variation (CV) | 0.33399179 |
| Kurtosis | 1347.1473 |
| Mean | 1.8757952 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 19.859578 |
| Sum | 163937 |
| Variance | 0.39250251 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 2 | 64497 | |
| 1 | 16503 | 18.9% |
| 3 | 5935 | 6.8% |
| 0 | 385 | 0.4% |
| 4 | 60 | 0.1% |
| 26 | 5 | < 0.1% |
| 27 | 2 | < 0.1% |
| 20 | 2 | < 0.1% |
| 5 | 2 | < 0.1% |
| 40 | 1 | < 0.1% |
| Other values (4) | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 385 | 0.4% |
| 1 | 16503 | 18.9% |
| 2 | 64497 | |
| 3 | 5935 | 6.8% |
| 4 | 60 | 0.1% |
| 5 | 2 | < 0.1% |
| 6 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 26 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 55 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| 27 | 2 | < 0.1% |
| 26 | 5 | < 0.1% |
| 20 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 5 | 2 | < 0.1% |
| 4 | 60 |
children
Real number (ℝ)
Zeros
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.13863969 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 79028 |
| Zeros (%) | 90.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 682.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.45587044 |
|---|---|
| Coefficient of variation (CV) | 3.2881668 |
| Kurtosis | 12.957806 |
| Mean | 0.13863969 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.4636519 |
| Sum | 12116.555 |
| Variance | 0.20781786 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 79028 | |
| 1 | 4695 | 5.4% |
| 2 | 3593 | 4.1% |
| 3 | 75 | 0.1% |
| 0.1386396924 | 4 | < 0.1% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 79028 | |
| 0.1386396924 | 4 | < 0.1% |
| 1 | 4695 | 5.4% |
| 2 | 3593 | 4.1% |
| 3 | 75 | 0.1% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 10 | 1 | < 0.1% |
| 3 | 75 | 0.1% |
| 2 | 3593 | 4.1% |
| 1 | 4695 | 5.4% |
| 0.1386396924 | 4 | < 0.1% |
| 0 | 79028 |
babies
Categorical
Imbalance
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| 0 | |
|---|---|
| 1 | 897 |
| 2 | 15 |
| 10 | 1 |
| 9 | 1 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.0000114 |
| Min length | 1 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 86482 | |
| 1 | 897 | 1.0% |
| 2 | 15 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 86482 | |
| 1 | 897 | 1.0% |
| 2 | 15 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 86483 | |
| 1 | 898 | 1.0% |
| 2 | 15 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 87397 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 86483 | |
| 1 | 898 | 1.0% |
| 2 | 15 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 87397 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 86483 | |
| 1 | 898 | 1.0% |
| 2 | 15 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 87397 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 86483 | |
| 1 | 898 | 1.0% |
| 2 | 15 | < 0.1% |
| 9 | 1 | < 0.1% |
meal
Categorical
Imbalance
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| BB | |
|---|---|
| SC | |
| HB | |
| Undefined | 492 |
| FB | 360 |
Length
| Max length | 9 |
|---|---|
| Median length | 2 |
| Mean length | 2.0394068 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BB |
|---|---|
| 2nd row | BB |
| 3rd row | BB |
| 4th row | BB |
| 5th row | BB |
Common Values
| Value | Count | Frequency (%) |
| BB | 67978 | |
| SC | 9481 | 10.8% |
| HB | 9085 | 10.4% |
| Undefined | 492 | 0.6% |
| FB | 360 | 0.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| bb | 67978 | |
| sc | 9481 | 10.8% |
| hb | 9085 | 10.4% |
| undefined | 492 | 0.6% |
| fb | 360 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 145401 | |
| S | 9481 | 5.3% |
| C | 9481 | 5.3% |
| H | 9085 | 5.1% |
| n | 984 | 0.6% |
| d | 984 | 0.6% |
| e | 984 | 0.6% |
| U | 492 | 0.3% |
| f | 492 | 0.3% |
| i | 492 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 178236 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 145401 | |
| S | 9481 | 5.3% |
| C | 9481 | 5.3% |
| H | 9085 | 5.1% |
| n | 984 | 0.6% |
| d | 984 | 0.6% |
| e | 984 | 0.6% |
| U | 492 | 0.3% |
| f | 492 | 0.3% |
| i | 492 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 178236 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 145401 | |
| S | 9481 | 5.3% |
| C | 9481 | 5.3% |
| H | 9085 | 5.1% |
| n | 984 | 0.6% |
| d | 984 | 0.6% |
| e | 984 | 0.6% |
| U | 492 | 0.3% |
| f | 492 | 0.3% |
| i | 492 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 178236 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 145401 | |
| S | 9481 | 5.3% |
| C | 9481 | 5.3% |
| H | 9085 | 5.1% |
| n | 984 | 0.6% |
| d | 984 | 0.6% |
| e | 984 | 0.6% |
| U | 492 | 0.3% |
| f | 492 | 0.3% |
| i | 492 | 0.3% |
country
Text
| Distinct | 178 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 2.9926656 |
| Min length | 2 |
Unique
| Unique | 32 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PRT |
|---|---|
| 2nd row | PRT |
| 3rd row | GBR |
| 4th row | GBR |
| 5th row | GBR |
| Value | Count | Frequency (%) |
| prt | 27453 | |
| gbr | 10433 | 11.9% |
| fra | 8837 | 10.1% |
| esp | 7252 | 8.3% |
| deu | 5387 | 6.2% |
| ita | 3066 | 3.5% |
| irl | 3016 | 3.5% |
| bel | 2081 | 2.4% |
| bra | 1995 | 2.3% |
| nld | 1911 | 2.2% |
| Other values (168) | 15965 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 55143 | |
| P | 35858 | |
| T | 32024 | |
| A | 18408 | 7.0% |
| E | 17646 | 6.7% |
| B | 14789 | 5.7% |
| S | 11697 | 4.5% |
| G | 11357 | 4.3% |
| U | 11035 | 4.2% |
| L | 9430 | 3.6% |
| Other values (16) | 44160 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 261547 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| R | 55143 | |
| P | 35858 | |
| T | 32024 | |
| A | 18408 | 7.0% |
| E | 17646 | 6.7% |
| B | 14789 | 5.7% |
| S | 11697 | 4.5% |
| G | 11357 | 4.3% |
| U | 11035 | 4.2% |
| L | 9430 | 3.6% |
| Other values (16) | 44160 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 261547 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| R | 55143 | |
| P | 35858 | |
| T | 32024 | |
| A | 18408 | 7.0% |
| E | 17646 | 6.7% |
| B | 14789 | 5.7% |
| S | 11697 | 4.5% |
| G | 11357 | 4.3% |
| U | 11035 | 4.2% |
| L | 9430 | 3.6% |
| Other values (16) | 44160 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 261547 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| R | 55143 | |
| P | 35858 | |
| T | 32024 | |
| A | 18408 | 7.0% |
| E | 17646 | 6.7% |
| B | 14789 | 5.7% |
| S | 11697 | 4.5% |
| G | 11357 | 4.3% |
| U | 11035 | 4.2% |
| L | 9430 | 3.6% |
| Other values (16) | 44160 |
market_segment
Categorical
High correlation
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| Online TA | |
|---|---|
| Offline TA/TO | |
| Direct | |
| Groups | 4942 |
| Corporate | 4212 |
| Other values (3) | 931 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.0903817 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | Direct |
| 3rd row | Direct |
| 4th row | Corporate |
| 5th row | Online TA |
Common Values
| Value | Count | Frequency (%) |
| Online TA | 51618 | |
| Offline TA/TO | 13889 | 15.9% |
| Direct | 11804 | 13.5% |
| Groups | 4942 | 5.7% |
| Corporate | 4212 | 4.8% |
| Complementary | 702 | 0.8% |
| Aviation | 227 | 0.3% |
| Undefined | 2 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| online | 51618 | |
| ta | 51618 | |
| offline | 13889 | 9.1% |
| ta/to | 13889 | 9.1% |
| direct | 11804 | 7.7% |
| groups | 4942 | 3.2% |
| corporate | 4212 | 2.8% |
| complementary | 702 | 0.5% |
| aviation | 227 | 0.1% |
| undefined | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 118058 | |
| e | 82931 | |
| O | 79396 | |
| T | 79396 | |
| i | 77767 | |
| l | 66209 | |
| A | 65734 | |
| 65507 | ||
| f | 27780 | 3.5% |
| r | 25872 | 3.3% |
| Other values (16) | 105813 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 794463 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 118058 | |
| e | 82931 | |
| O | 79396 | |
| T | 79396 | |
| i | 77767 | |
| l | 66209 | |
| A | 65734 | |
| 65507 | ||
| f | 27780 | 3.5% |
| r | 25872 | 3.3% |
| Other values (16) | 105813 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 794463 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 118058 | |
| e | 82931 | |
| O | 79396 | |
| T | 79396 | |
| i | 77767 | |
| l | 66209 | |
| A | 65734 | |
| 65507 | ||
| f | 27780 | 3.5% |
| r | 25872 | 3.3% |
| Other values (16) | 105813 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 794463 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 118058 | |
| e | 82931 | |
| O | 79396 | |
| T | 79396 | |
| i | 77767 | |
| l | 66209 | |
| A | 65734 | |
| 65507 | ||
| f | 27780 | 3.5% |
| r | 25872 | 3.3% |
| Other values (16) | 105813 |
distribution_channel
Categorical
High correlation Imbalance
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| TA/TO | |
|---|---|
| Direct | |
| Corporate | 5081 |
| GDS | 181 |
| Undefined | 5 |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.3772484 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | Direct |
| 3rd row | Direct |
| 4th row | Corporate |
| 5th row | TA/TO |
Common Values
| Value | Count | Frequency (%) |
| TA/TO | 69141 | |
| Direct | 12988 | 14.9% |
| Corporate | 5081 | 5.8% |
| GDS | 181 | 0.2% |
| Undefined | 5 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ta/to | 69141 | |
| direct | 12988 | 14.9% |
| corporate | 5081 | 5.8% |
| gds | 181 | 0.2% |
| undefined | 5 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 138282 | |
| / | 69141 | |
| O | 69141 | |
| A | 69141 | |
| r | 23150 | 4.9% |
| e | 18079 | 3.8% |
| t | 18069 | 3.8% |
| D | 13169 | 2.8% |
| i | 12993 | 2.8% |
| c | 12988 | 2.8% |
| Other values (10) | 25797 | 5.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 469950 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| T | 138282 | |
| / | 69141 | |
| O | 69141 | |
| A | 69141 | |
| r | 23150 | 4.9% |
| e | 18079 | 3.8% |
| t | 18069 | 3.8% |
| D | 13169 | 2.8% |
| i | 12993 | 2.8% |
| c | 12988 | 2.8% |
| Other values (10) | 25797 | 5.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 469950 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| T | 138282 | |
| / | 69141 | |
| O | 69141 | |
| A | 69141 | |
| r | 23150 | 4.9% |
| e | 18079 | 3.8% |
| t | 18069 | 3.8% |
| D | 13169 | 2.8% |
| i | 12993 | 2.8% |
| c | 12988 | 2.8% |
| Other values (10) | 25797 | 5.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 469950 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| T | 138282 | |
| / | 69141 | |
| O | 69141 | |
| A | 69141 | |
| r | 23150 | 4.9% |
| e | 18079 | 3.8% |
| t | 18069 | 3.8% |
| D | 13169 | 2.8% |
| i | 12993 | 2.8% |
| c | 12988 | 2.8% |
| Other values (10) | 25797 | 5.5% |
is_repeated_guest
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| 0 | |
|---|---|
| 1 | 3415 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 83981 | |
| 1 | 3415 | 3.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 83981 | |
| 1 | 3415 | 3.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 83981 | |
| 1 | 3415 | 3.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 83981 | |
| 1 | 3415 | 3.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 83981 | |
| 1 | 3415 | 3.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 83981 | |
| 1 | 3415 | 3.9% |
previous_cancellations
Real number (ℝ)
Skewed Zeros
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.030413291 |
| Minimum | 0 |
|---|---|
| Maximum | 26 |
| Zeros | 85711 |
| Zeros (%) | 98.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 682.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.36914526 |
|---|---|
| Coefficient of variation (CV) | 12.13763 |
| Kurtosis | 1726.0943 |
| Mean | 0.030413291 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 34.323744 |
| Sum | 2658 |
| Variance | 0.13626822 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 0 | 85711 | |
| 1 | 1407 | 1.6% |
| 2 | 112 | 0.1% |
| 3 | 61 | 0.1% |
| 4 | 30 | < 0.1% |
| 11 | 27 | < 0.1% |
| 5 | 19 | < 0.1% |
| 6 | 17 | < 0.1% |
| 13 | 4 | < 0.1% |
| 25 | 2 | < 0.1% |
| Other values (5) | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 85711 | |
| 1 | 1407 | 1.6% |
| 2 | 112 | 0.1% |
| 3 | 61 | 0.1% |
| 4 | 30 | < 0.1% |
| 5 | 19 | < 0.1% |
| 6 | 17 | < 0.1% |
| 11 | 27 | < 0.1% |
| 13 | 4 | < 0.1% |
| 14 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 26 | 1 | < 0.1% |
| 25 | 2 | < 0.1% |
| 24 | 2 | < 0.1% |
| 21 | 1 | < 0.1% |
| 19 | 1 | < 0.1% |
| 14 | 1 | < 0.1% |
| 13 | 4 | < 0.1% |
| 11 | 27 | |
| 6 | 17 | |
| 5 | 19 |
previous_bookings_not_canceled
Real number (ℝ)
Skewed Zeros
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.18399011 |
| Minimum | 0 |
|---|---|
| Maximum | 72 |
| Zeros | 83851 |
| Zeros (%) | 95.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 682.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 72 |
| Range | 72 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.7318937 |
|---|---|
| Coefficient of variation (CV) | 9.4129715 |
| Kurtosis | 579.3979 |
| Mean | 0.18399011 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 20.459725 |
| Sum | 16080 |
| Variance | 2.9994558 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 83851 | |
| 1 | 1482 | 1.7% |
| 2 | 580 | 0.7% |
| 3 | 331 | 0.4% |
| 4 | 228 | 0.3% |
| 5 | 181 | 0.2% |
| 6 | 114 | 0.1% |
| 7 | 87 | 0.1% |
| 8 | 70 | 0.1% |
| 9 | 59 | 0.1% |
| Other values (63) | 413 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 83851 | |
| 1 | 1482 | 1.7% |
| 2 | 580 | 0.7% |
| 3 | 331 | 0.4% |
| 4 | 228 | 0.3% |
| 5 | 181 | 0.2% |
| 6 | 114 | 0.1% |
| 7 | 87 | 0.1% |
| 8 | 70 | 0.1% |
| 9 | 59 | 0.1% |
| Value | Count | Frequency (%) |
| 72 | 1 | |
| 71 | 1 | |
| 70 | 1 | |
| 69 | 1 | |
| 68 | 1 | |
| 67 | 1 | |
| 66 | 1 | |
| 65 | 1 | |
| 64 | 1 | |
| 63 | 1 |
reserved_room_type
Categorical
High correlation Imbalance
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| A | |
|---|---|
| D | |
| E | |
| F | 2823 |
| G | 2052 |
| Other values (5) | 2522 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 56552 | |
| D | 17398 | 19.9% |
| E | 6049 | 6.9% |
| F | 2823 | 3.2% |
| G | 2052 | 2.3% |
| B | 999 | 1.1% |
| C | 915 | 1.0% |
| H | 596 | 0.7% |
| L | 6 | < 0.1% |
| P | 6 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 56552 | |
| d | 17398 | 19.9% |
| e | 6049 | 6.9% |
| f | 2823 | 3.2% |
| g | 2052 | 2.3% |
| b | 999 | 1.1% |
| c | 915 | 1.0% |
| h | 596 | 0.7% |
| l | 6 | < 0.1% |
| p | 6 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 56552 | |
| D | 17398 | 19.9% |
| E | 6049 | 6.9% |
| F | 2823 | 3.2% |
| G | 2052 | 2.3% |
| B | 999 | 1.1% |
| C | 915 | 1.0% |
| H | 596 | 0.7% |
| L | 6 | < 0.1% |
| P | 6 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 56552 | |
| D | 17398 | 19.9% |
| E | 6049 | 6.9% |
| F | 2823 | 3.2% |
| G | 2052 | 2.3% |
| B | 999 | 1.1% |
| C | 915 | 1.0% |
| H | 596 | 0.7% |
| L | 6 | < 0.1% |
| P | 6 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 56552 | |
| D | 17398 | 19.9% |
| E | 6049 | 6.9% |
| F | 2823 | 3.2% |
| G | 2052 | 2.3% |
| B | 999 | 1.1% |
| C | 915 | 1.0% |
| H | 596 | 0.7% |
| L | 6 | < 0.1% |
| P | 6 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 56552 | |
| D | 17398 | 19.9% |
| E | 6049 | 6.9% |
| F | 2823 | 3.2% |
| G | 2052 | 2.3% |
| B | 999 | 1.1% |
| C | 915 | 1.0% |
| H | 596 | 0.7% |
| L | 6 | < 0.1% |
| P | 6 | < 0.1% |
assigned_room_type
Categorical
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| A | |
|---|---|
| D | |
| E | |
| F | 3627 |
| G | 2498 |
| Other values (7) |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | C |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 46313 | |
| D | 22432 | |
| E | 7195 | 8.2% |
| F | 3627 | 4.2% |
| G | 2498 | 2.9% |
| C | 2165 | 2.5% |
| B | 1820 | 2.1% |
| H | 706 | 0.8% |
| I | 357 | 0.4% |
| K | 276 | 0.3% |
| Other values (2) | 7 | < 0.1% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| a | 46313 | |
| d | 22432 | |
| e | 7195 | 8.2% |
| f | 3627 | 4.2% |
| g | 2498 | 2.9% |
| c | 2165 | 2.5% |
| b | 1820 | 2.1% |
| h | 706 | 0.8% |
| i | 357 | 0.4% |
| k | 276 | 0.3% |
| Other values (2) | 7 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 46313 | |
| D | 22432 | |
| E | 7195 | 8.2% |
| F | 3627 | 4.2% |
| G | 2498 | 2.9% |
| C | 2165 | 2.5% |
| B | 1820 | 2.1% |
| H | 706 | 0.8% |
| I | 357 | 0.4% |
| K | 276 | 0.3% |
| Other values (2) | 7 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 46313 | |
| D | 22432 | |
| E | 7195 | 8.2% |
| F | 3627 | 4.2% |
| G | 2498 | 2.9% |
| C | 2165 | 2.5% |
| B | 1820 | 2.1% |
| H | 706 | 0.8% |
| I | 357 | 0.4% |
| K | 276 | 0.3% |
| Other values (2) | 7 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 46313 | |
| D | 22432 | |
| E | 7195 | 8.2% |
| F | 3627 | 4.2% |
| G | 2498 | 2.9% |
| C | 2165 | 2.5% |
| B | 1820 | 2.1% |
| H | 706 | 0.8% |
| I | 357 | 0.4% |
| K | 276 | 0.3% |
| Other values (2) | 7 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 46313 | |
| D | 22432 | |
| E | 7195 | 8.2% |
| F | 3627 | 4.2% |
| G | 2498 | 2.9% |
| C | 2165 | 2.5% |
| B | 1820 | 2.1% |
| H | 706 | 0.8% |
| I | 357 | 0.4% |
| K | 276 | 0.3% |
| Other values (2) | 7 | < 0.1% |
booking_changes
Real number (ℝ)
Zeros
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.27160282 |
| Minimum | 0 |
|---|---|
| Maximum | 21 |
| Zeros | 71494 |
| Zeros (%) | 81.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 682.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.72724527 |
|---|---|
| Coefficient of variation (CV) | 2.6776057 |
| Kurtosis | 67.615632 |
| Mean | 0.27160282 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.5463283 |
| Sum | 23737 |
| Variance | 0.52888568 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 0 | 71494 | |
| 1 | 10902 | 12.5% |
| 2 | 3508 | 4.0% |
| 3 | 875 | 1.0% |
| 4 | 356 | 0.4% |
| 5 | 116 | 0.1% |
| 6 | 59 | 0.1% |
| 7 | 31 | < 0.1% |
| 8 | 17 | < 0.1% |
| 9 | 8 | < 0.1% |
| Other values (11) | 30 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 71494 | |
| 1 | 10902 | 12.5% |
| 2 | 3508 | 4.0% |
| 3 | 875 | 1.0% |
| 4 | 356 | 0.4% |
| 5 | 116 | 0.1% |
| 6 | 59 | 0.1% |
| 7 | 31 | < 0.1% |
| 8 | 17 | < 0.1% |
| 9 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 18 | 1 | < 0.1% |
| 17 | 2 | < 0.1% |
| 16 | 2 | < 0.1% |
| 15 | 3 | |
| 14 | 5 | |
| 13 | 5 | |
| 12 | 2 | < 0.1% |
| 11 | 2 | < 0.1% |
deposit_type
Categorical
Imbalance
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| No Deposit | |
|---|---|
| Non Refund | 1038 |
| Refundable | 107 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Deposit |
|---|---|
| 2nd row | No Deposit |
| 3rd row | No Deposit |
| 4th row | No Deposit |
| 5th row | No Deposit |
Common Values
| Value | Count | Frequency (%) |
| No Deposit | 86251 | |
| Non Refund | 1038 | 1.2% |
| Refundable | 107 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 86251 | |
| deposit | 86251 | |
| non | 1038 | 0.6% |
| refund | 1038 | 0.6% |
| refundable | 107 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 173540 | |
| e | 87503 | |
| N | 87289 | |
| 87289 | ||
| s | 86251 | |
| i | 86251 | |
| t | 86251 | |
| p | 86251 | |
| D | 86251 | |
| n | 2183 | 0.2% |
| Other values (7) | 4901 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 873960 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 173540 | |
| e | 87503 | |
| N | 87289 | |
| 87289 | ||
| s | 86251 | |
| i | 86251 | |
| t | 86251 | |
| p | 86251 | |
| D | 86251 | |
| n | 2183 | 0.2% |
| Other values (7) | 4901 | 0.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 873960 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 173540 | |
| e | 87503 | |
| N | 87289 | |
| 87289 | ||
| s | 86251 | |
| i | 86251 | |
| t | 86251 | |
| p | 86251 | |
| D | 86251 | |
| n | 2183 | 0.2% |
| Other values (7) | 4901 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 873960 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 173540 | |
| e | 87503 | |
| N | 87289 | |
| 87289 | ||
| s | 86251 | |
| i | 86251 | |
| t | 86251 | |
| p | 86251 | |
| D | 86251 | |
| n | 2183 | 0.2% |
| Other values (7) | 4901 | 0.6% |
agent
Text
| Distinct | 334 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 2.1623873 |
| Min length | 1 |
Unique
| Unique | 59 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | NULL |
|---|---|
| 2nd row | NULL |
| 3rd row | NULL |
| 4th row | 304 |
| 5th row | 240 |
| Value | Count | Frequency (%) |
| 9 | 28759 | |
| 240 | 13028 | |
| null | 12193 | |
| 14 | 3349 | 3.8% |
| 7 | 3300 | 3.8% |
| 250 | 2779 | 3.2% |
| 241 | 1644 | 1.9% |
| 28 | 1502 | 1.7% |
| 8 | 1383 | 1.6% |
| 1 | 1232 | 1.4% |
| Other values (324) | 18227 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 31325 | |
| 2 | 25444 | |
| L | 24386 | |
| 4 | 23445 | |
| 0 | 17970 | |
| 1 | 14829 | |
| N | 12193 | 6.5% |
| U | 12193 | 6.5% |
| 5 | 6328 | 3.3% |
| 7 | 6165 | 3.3% |
| Other values (3) | 14706 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 188984 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 9 | 31325 | |
| 2 | 25444 | |
| L | 24386 | |
| 4 | 23445 | |
| 0 | 17970 | |
| 1 | 14829 | |
| N | 12193 | 6.5% |
| U | 12193 | 6.5% |
| 5 | 6328 | 3.3% |
| 7 | 6165 | 3.3% |
| Other values (3) | 14706 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 188984 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 9 | 31325 | |
| 2 | 25444 | |
| L | 24386 | |
| 4 | 23445 | |
| 0 | 17970 | |
| 1 | 14829 | |
| N | 12193 | 6.5% |
| U | 12193 | 6.5% |
| 5 | 6328 | 3.3% |
| 7 | 6165 | 3.3% |
| Other values (3) | 14706 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 188984 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 9 | 31325 | |
| 2 | 25444 | |
| L | 24386 | |
| 4 | 23445 | |
| 0 | 17970 | |
| 1 | 14829 | |
| N | 12193 | 6.5% |
| U | 12193 | 6.5% |
| 5 | 6328 | 3.3% |
| 7 | 6165 | 3.3% |
| Other values (3) | 14706 |
company
Text
| Distinct | 353 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.9178681 |
| Min length | 1 |
Unique
| Unique | 90 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | NULL |
|---|---|
| 2nd row | NULL |
| 3rd row | NULL |
| 4th row | NULL |
| 5th row | NULL |
| Value | Count | Frequency (%) |
| null | 82137 | |
| 40 | 851 | 1.0% |
| 223 | 503 | 0.6% |
| 45 | 238 | 0.3% |
| 153 | 206 | 0.2% |
| 154 | 133 | 0.2% |
| 219 | 131 | 0.1% |
| 174 | 121 | 0.1% |
| 281 | 119 | 0.1% |
| 233 | 95 | 0.1% |
| Other values (343) | 2862 | 3.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 164274 | |
| N | 82137 | |
| U | 82137 | |
| 2 | 2380 | 0.7% |
| 4 | 2253 | 0.7% |
| 3 | 1915 | 0.6% |
| 1 | 1902 | 0.6% |
| 0 | 1468 | 0.4% |
| 5 | 1185 | 0.3% |
| 8 | 785 | 0.2% |
| Other values (3) | 1970 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 342406 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| L | 164274 | |
| N | 82137 | |
| U | 82137 | |
| 2 | 2380 | 0.7% |
| 4 | 2253 | 0.7% |
| 3 | 1915 | 0.6% |
| 1 | 1902 | 0.6% |
| 0 | 1468 | 0.4% |
| 5 | 1185 | 0.3% |
| 8 | 785 | 0.2% |
| Other values (3) | 1970 | 0.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 342406 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| L | 164274 | |
| N | 82137 | |
| U | 82137 | |
| 2 | 2380 | 0.7% |
| 4 | 2253 | 0.7% |
| 3 | 1915 | 0.6% |
| 1 | 1902 | 0.6% |
| 0 | 1468 | 0.4% |
| 5 | 1185 | 0.3% |
| 8 | 785 | 0.2% |
| Other values (3) | 1970 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 342406 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| L | 164274 | |
| N | 82137 | |
| U | 82137 | |
| 2 | 2380 | 0.7% |
| 4 | 2253 | 0.7% |
| 3 | 1915 | 0.6% |
| 1 | 1902 | 0.6% |
| 0 | 1468 | 0.4% |
| 5 | 1185 | 0.3% |
| 8 | 785 | 0.2% |
| Other values (3) | 1970 | 0.6% |
days_in_waiting_list
Real number (ℝ)
Zeros
| Distinct | 128 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7495652 |
| Minimum | 0 |
|---|---|
| Maximum | 391 |
| Zeros | 86536 |
| Zeros (%) | 99.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 682.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 391 |
| Range | 391 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 10.015731 |
|---|---|
| Coefficient of variation (CV) | 13.362054 |
| Kurtosis | 480.60911 |
| Mean | 0.7495652 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 19.396419 |
| Sum | 65509 |
| Variance | 100.31487 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 86536 | |
| 63 | 53 | 0.1% |
| 87 | 25 | < 0.1% |
| 44 | 23 | < 0.1% |
| 15 | 22 | < 0.1% |
| 58 | 21 | < 0.1% |
| 48 | 21 | < 0.1% |
| 122 | 21 | < 0.1% |
| 38 | 19 | < 0.1% |
| 77 | 17 | < 0.1% |
| Other values (118) | 638 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 86536 | |
| 1 | 12 | < 0.1% |
| 2 | 5 | < 0.1% |
| 3 | 2 | < 0.1% |
| 4 | 15 | < 0.1% |
| 5 | 8 | < 0.1% |
| 6 | 9 | < 0.1% |
| 7 | 4 | < 0.1% |
| 8 | 7 | < 0.1% |
| 9 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 391 | 5 | |
| 379 | 3 | < 0.1% |
| 330 | 4 | < 0.1% |
| 259 | 9 | |
| 236 | 7 | |
| 224 | 5 | |
| 223 | 10 | |
| 215 | 4 | < 0.1% |
| 207 | 5 | |
| 193 | 1 | < 0.1% |
customer_type
Categorical
Imbalance
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| Transient | |
|---|---|
| Transient-Party | |
| Contract | 3139 |
| Group | 544 |
Length
| Max length | 15 |
|---|---|
| Median length | 9 |
| Mean length | 9.7442789 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Transient |
|---|---|
| 2nd row | Transient |
| 3rd row | Transient |
| 4th row | Transient |
| 5th row | Transient |
Common Values
| Value | Count | Frequency (%) |
| Transient | 71986 | |
| Transient-Party | 11727 | 13.4% |
| Contract | 3139 | 3.6% |
| Group | 544 | 0.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| transient | 71986 | |
| transient-party | 11727 | 13.4% |
| contract | 3139 | 3.6% |
| group | 544 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 170565 | |
| t | 101718 | |
| r | 99123 | |
| a | 98579 | |
| T | 83713 | |
| s | 83713 | |
| i | 83713 | |
| e | 83713 | |
| y | 11727 | 1.4% |
| - | 11727 | 1.4% |
| Other values (7) | 23320 | 2.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 851611 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 170565 | |
| t | 101718 | |
| r | 99123 | |
| a | 98579 | |
| T | 83713 | |
| s | 83713 | |
| i | 83713 | |
| e | 83713 | |
| y | 11727 | 1.4% |
| - | 11727 | 1.4% |
| Other values (7) | 23320 | 2.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 851611 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 170565 | |
| t | 101718 | |
| r | 99123 | |
| a | 98579 | |
| T | 83713 | |
| s | 83713 | |
| i | 83713 | |
| e | 83713 | |
| y | 11727 | 1.4% |
| - | 11727 | 1.4% |
| Other values (7) | 23320 | 2.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 851611 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 170565 | |
| t | 101718 | |
| r | 99123 | |
| a | 98579 | |
| T | 83713 | |
| s | 83713 | |
| i | 83713 | |
| e | 83713 | |
| y | 11727 | 1.4% |
| - | 11727 | 1.4% |
| Other values (7) | 23320 | 2.7% |
adr
Real number (ℝ)
Zeros
| Distinct | 8879 |
|---|---|
| Distinct (%) | 10.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 106.33725 |
| Minimum | -6.38 |
|---|---|
| Maximum | 5400 |
| Zeros | 1778 |
| Zeros (%) | 2.0% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 682.9 KiB |
Quantile statistics
| Minimum | -6.38 |
|---|---|
| 5-th percentile | 36.83 |
| Q1 | 72 |
| median | 98.1 |
| Q3 | 134 |
| 95-th percentile | 204 |
| Maximum | 5400 |
| Range | 5406.38 |
| Interquartile range (IQR) | 62 |
Descriptive statistics
| Standard deviation | 55.013953 |
|---|---|
| Coefficient of variation (CV) | 0.51735356 |
| Kurtosis | 981.62077 |
| Mean | 106.33725 |
| Median Absolute Deviation (MAD) | 30.45 |
| Skewness | 10.921447 |
| Sum | 9293450 |
| Variance | 3026.5351 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1778 | 2.0% |
| 75 | 1320 | 1.5% |
| 65 | 1260 | 1.4% |
| 48 | 878 | 1.0% |
| 85 | 858 | 1.0% |
| 95 | 850 | 1.0% |
| 90 | 818 | 0.9% |
| 80 | 754 | 0.9% |
| 99 | 749 | 0.9% |
| 60 | 730 | 0.8% |
| Other values (8869) | 77401 |
| Value | Count | Frequency (%) |
| -6.38 | 1 | < 0.1% |
| 0 | 1778 | |
| 0.26 | 1 | < 0.1% |
| 0.5 | 1 | < 0.1% |
| 1 | 13 | < 0.1% |
| 1.29 | 1 | < 0.1% |
| 1.48 | 1 | < 0.1% |
| 1.56 | 2 | < 0.1% |
| 1.6 | 1 | < 0.1% |
| 1.8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5400 | 1 | |
| 510 | 1 | |
| 508 | 1 | |
| 451.5 | 1 | |
| 450 | 1 | |
| 437 | 1 | |
| 426.25 | 1 | |
| 402 | 1 | |
| 397.38 | 1 | |
| 392 | 2 |
required_car_parking_spaces
Categorical
Imbalance
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| 0 | |
|---|---|
| 1 | 7280 |
| 2 | 28 |
| 3 | 3 |
| 8 | 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 80083 | |
| 1 | 7280 | 8.3% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 80083 | |
| 1 | 7280 | 8.3% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 80083 | |
| 1 | 7280 | 8.3% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 80083 | |
| 1 | 7280 | 8.3% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 80083 | |
| 1 | 7280 | 8.3% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 87396 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 80083 | |
| 1 | 7280 | 8.3% |
| 2 | 28 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
total_of_special_requests
Real number (ℝ)
Zeros
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.69856744 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 43894 |
| Zeros (%) | 50.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 682.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.83194598 |
|---|---|
| Coefficient of variation (CV) | 1.1909315 |
| Kurtosis | 0.81986954 |
| Mean | 0.69856744 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.0828516 |
| Sum | 61052 |
| Variance | 0.69213411 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 43894 | |
| 1 | 29017 | |
| 2 | 11812 | 13.5% |
| 3 | 2317 | 2.7% |
| 4 | 320 | 0.4% |
| 5 | 36 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 43894 | |
| 1 | 29017 | |
| 2 | 11812 | 13.5% |
| 3 | 2317 | 2.7% |
| 4 | 320 | 0.4% |
| 5 | 36 | < 0.1% |
| Value | Count | Frequency (%) |
| 5 | 36 | < 0.1% |
| 4 | 320 | 0.4% |
| 3 | 2317 | 2.7% |
| 2 | 11812 | 13.5% |
| 1 | 29017 | |
| 0 | 43894 |
reservation_status
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| Check-Out | |
|---|---|
| Canceled | |
| No-Show | 1014 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.7134995 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Check-Out |
|---|---|
| 2nd row | Check-Out |
| 3rd row | Check-Out |
| 4th row | Check-Out |
| 5th row | Check-Out |
Common Values
| Value | Count | Frequency (%) |
| Check-Out | 63371 | |
| Canceled | 23011 | 26.3% |
| No-Show | 1014 | 1.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| check-out | 63371 | |
| canceled | 23011 | 26.3% |
| no-show | 1014 | 1.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 109393 | |
| C | 86382 | |
| c | 86382 | |
| h | 64385 | |
| - | 64385 | |
| u | 63371 | |
| t | 63371 | |
| O | 63371 | |
| k | 63371 | |
| a | 23011 | 3.0% |
| Other values (7) | 74103 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 761525 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 109393 | |
| C | 86382 | |
| c | 86382 | |
| h | 64385 | |
| - | 64385 | |
| u | 63371 | |
| t | 63371 | |
| O | 63371 | |
| k | 63371 | |
| a | 23011 | 3.0% |
| Other values (7) | 74103 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 761525 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 109393 | |
| C | 86382 | |
| c | 86382 | |
| h | 64385 | |
| - | 64385 | |
| u | 63371 | |
| t | 63371 | |
| O | 63371 | |
| k | 63371 | |
| a | 23011 | 3.0% |
| Other values (7) | 74103 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 761525 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 109393 | |
| C | 86382 | |
| c | 86382 | |
| h | 64385 | |
| - | 64385 | |
| u | 63371 | |
| t | 63371 | |
| O | 63371 | |
| k | 63371 | |
| a | 23011 | 3.0% |
| Other values (7) | 74103 |
| Distinct | 926 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 682.9 KiB |
| Minimum | 2014-10-17 00:00:00 |
|---|---|
| Maximum | 2017-09-14 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Interactions
Correlations
| adr | adults | arrival_date_day_of_month | arrival_date_month | arrival_date_week_number | arrival_date_year | assigned_room_type | babies | booking_changes | children | customer_type | days_in_waiting_list | deposit_type | distribution_channel | hotel | is_canceled | is_repeated_guest | lead_time | market_segment | meal | previous_bookings_not_canceled | previous_cancellations | required_car_parking_spaces | reservation_status | reserved_room_type | stays_in_week_nights | stays_in_weekend_nights | total_of_special_requests | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| adr | 1.000 | 0.340 | 0.019 | 0.000 | 0.114 | 0.000 | 0.000 | 0.000 | -0.011 | 0.284 | 0.000 | -0.045 | 0.030 | 0.000 | 0.000 | 0.000 | 0.000 | 0.108 | 0.000 | 0.000 | -0.175 | -0.081 | 0.000 | 0.003 | 0.000 | 0.085 | 0.048 | 0.162 |
| adults | 0.340 | 1.000 | 0.003 | 0.013 | 0.026 | 0.020 | 0.000 | 0.000 | -0.074 | 0.070 | 0.092 | -0.033 | 0.000 | 0.008 | 0.014 | 0.019 | 0.000 | 0.233 | 0.008 | 0.000 | -0.245 | -0.087 | 0.000 | 0.013 | 0.000 | 0.173 | 0.132 | 0.159 |
| arrival_date_day_of_month | 0.019 | 0.003 | 1.000 | 0.049 | 0.088 | 0.025 | 0.009 | 0.005 | 0.005 | 0.017 | 0.023 | 0.012 | 0.039 | 0.023 | 0.023 | 0.012 | 0.014 | 0.012 | 0.019 | 0.021 | -0.002 | -0.004 | 0.006 | 0.010 | 0.008 | -0.017 | -0.009 | -0.003 |
| arrival_date_month | 0.000 | 0.013 | 0.049 | 1.000 | 0.800 | 0.410 | 0.028 | 0.017 | 0.010 | 0.049 | 0.100 | 0.035 | 0.051 | 0.070 | 0.059 | 0.085 | 0.094 | 0.122 | 0.077 | 0.068 | 0.019 | 0.021 | 0.014 | 0.069 | 0.047 | 0.039 | 0.049 | 0.043 |
| arrival_date_week_number | 0.114 | 0.026 | 0.088 | 0.800 | 1.000 | 0.404 | 0.028 | 0.015 | 0.018 | 0.017 | 0.099 | -0.000 | 0.047 | 0.063 | 0.059 | 0.076 | 0.095 | 0.097 | 0.069 | 0.062 | -0.047 | 0.048 | 0.011 | 0.062 | 0.044 | 0.041 | 0.037 | 0.044 |
| arrival_date_year | 0.000 | 0.020 | 0.025 | 0.410 | 0.404 | 1.000 | 0.053 | 0.018 | 0.011 | 0.019 | 0.185 | 0.034 | 0.022 | 0.043 | 0.104 | 0.088 | 0.026 | 0.103 | 0.119 | 0.096 | 0.026 | 0.024 | 0.030 | 0.066 | 0.062 | 0.023 | 0.021 | 0.057 |
| assigned_room_type | 0.000 | 0.000 | 0.009 | 0.028 | 0.028 | 0.053 | 1.000 | 0.042 | 0.050 | 0.325 | 0.083 | 0.014 | 0.061 | 0.084 | 0.371 | 0.094 | 0.068 | 0.028 | 0.080 | 0.151 | 0.002 | 0.000 | 0.079 | 0.067 | 0.778 | 0.043 | 0.045 | 0.033 |
| babies | 0.000 | 0.000 | 0.005 | 0.017 | 0.015 | 0.018 | 0.042 | 1.000 | 0.015 | 0.000 | 0.007 | 0.000 | 0.005 | 0.028 | 0.044 | 0.020 | 0.012 | 0.000 | 0.031 | 0.026 | 0.000 | 0.000 | 0.016 | 0.014 | 0.036 | 0.000 | 0.006 | 0.059 |
| booking_changes | -0.011 | -0.074 | 0.005 | 0.010 | 0.018 | 0.011 | 0.050 | 0.015 | 1.000 | 0.048 | 0.052 | 0.044 | 0.000 | 0.026 | 0.030 | 0.032 | 0.000 | 0.056 | 0.031 | 0.020 | 0.018 | -0.016 | 0.011 | 0.022 | 0.010 | 0.052 | 0.022 | -0.005 |
| children | 0.284 | 0.070 | 0.017 | 0.049 | 0.017 | 0.019 | 0.325 | 0.000 | 0.048 | 1.000 | 0.031 | -0.029 | 0.015 | 0.033 | 0.026 | 0.067 | 0.033 | 0.051 | 0.068 | 0.039 | -0.052 | -0.030 | 0.013 | 0.053 | 0.385 | 0.045 | 0.036 | 0.056 |
| customer_type | 0.000 | 0.092 | 0.023 | 0.100 | 0.099 | 0.185 | 0.083 | 0.007 | 0.052 | 0.031 | 1.000 | 0.092 | 0.050 | 0.089 | 0.061 | 0.127 | 0.108 | 0.111 | 0.327 | 0.098 | 0.010 | 0.000 | 0.026 | 0.090 | 0.092 | 0.087 | 0.100 | 0.076 |
| days_in_waiting_list | -0.045 | -0.033 | 0.012 | 0.035 | -0.000 | 0.034 | 0.014 | 0.000 | 0.044 | -0.029 | 0.092 | 1.000 | 0.115 | 0.013 | 0.048 | 0.014 | 0.011 | 0.098 | 0.073 | 0.050 | -0.006 | 0.020 | 0.047 | 0.010 | 0.015 | 0.006 | -0.038 | -0.070 |
| deposit_type | 0.030 | 0.000 | 0.039 | 0.051 | 0.047 | 0.022 | 0.061 | 0.005 | 0.000 | 0.015 | 0.050 | 0.115 | 1.000 | 0.036 | 0.056 | 0.165 | 0.015 | 0.174 | 0.214 | 0.032 | 0.000 | 0.049 | 0.034 | 0.119 | 0.048 | 0.012 | 0.019 | 0.077 |
| distribution_channel | 0.000 | 0.008 | 0.023 | 0.070 | 0.063 | 0.043 | 0.084 | 0.028 | 0.026 | 0.033 | 0.089 | 0.013 | 0.036 | 1.000 | 0.141 | 0.152 | 0.354 | 0.103 | 0.716 | 0.087 | 0.125 | 0.053 | 0.072 | 0.113 | 0.100 | 0.013 | 0.069 | 0.097 |
| hotel | 0.000 | 0.014 | 0.023 | 0.059 | 0.059 | 0.104 | 0.371 | 0.044 | 0.030 | 0.026 | 0.061 | 0.048 | 0.056 | 0.141 | 1.000 | 0.071 | 0.046 | 0.090 | 0.180 | 0.348 | 0.023 | 0.025 | 0.218 | 0.073 | 0.311 | 0.182 | 0.184 | 0.022 |
| is_canceled | 0.000 | 0.019 | 0.012 | 0.085 | 0.076 | 0.088 | 0.094 | 0.020 | 0.032 | 0.067 | 0.127 | 0.014 | 0.165 | 0.152 | 0.071 | 1.000 | 0.090 | 0.168 | 0.221 | 0.063 | 0.037 | 0.015 | 0.186 | 1.000 | 0.057 | 0.045 | 0.059 | 0.131 |
| is_repeated_guest | 0.000 | 0.000 | 0.014 | 0.094 | 0.095 | 0.026 | 0.068 | 0.012 | 0.000 | 0.033 | 0.108 | 0.011 | 0.015 | 0.354 | 0.046 | 0.090 | 1.000 | 0.138 | 0.396 | 0.070 | 0.337 | 0.196 | 0.073 | 0.091 | 0.059 | 0.024 | 0.103 | 0.046 |
| lead_time | 0.108 | 0.233 | 0.012 | 0.122 | 0.097 | 0.103 | 0.028 | 0.000 | 0.056 | 0.051 | 0.111 | 0.098 | 0.174 | 0.103 | 0.090 | 0.168 | 0.138 | 1.000 | 0.129 | 0.070 | -0.198 | -0.000 | 0.041 | 0.126 | 0.036 | 0.418 | 0.295 | 0.063 |
| market_segment | 0.000 | 0.008 | 0.019 | 0.077 | 0.069 | 0.119 | 0.080 | 0.031 | 0.031 | 0.068 | 0.327 | 0.073 | 0.214 | 0.716 | 0.180 | 0.221 | 0.396 | 0.129 | 1.000 | 0.164 | 0.106 | 0.056 | 0.075 | 0.162 | 0.102 | 0.045 | 0.079 | 0.163 |
| meal | 0.000 | 0.000 | 0.021 | 0.068 | 0.062 | 0.096 | 0.151 | 0.026 | 0.020 | 0.039 | 0.098 | 0.050 | 0.032 | 0.087 | 0.348 | 0.063 | 0.070 | 0.070 | 0.164 | 1.000 | 0.015 | 0.036 | 0.039 | 0.046 | 0.135 | 0.058 | 0.081 | 0.039 |
| previous_bookings_not_canceled | -0.175 | -0.245 | -0.002 | 0.019 | -0.047 | 0.026 | 0.002 | 0.000 | 0.018 | -0.052 | 0.010 | -0.006 | 0.000 | 0.125 | 0.023 | 0.037 | 0.337 | -0.198 | 0.106 | 0.015 | 1.000 | 0.243 | 0.016 | 0.026 | 0.008 | -0.139 | -0.113 | -0.004 |
| previous_cancellations | -0.081 | -0.087 | -0.004 | 0.021 | 0.048 | 0.024 | 0.000 | 0.000 | -0.016 | -0.030 | 0.000 | 0.020 | 0.049 | 0.053 | 0.025 | 0.015 | 0.196 | -0.000 | 0.056 | 0.036 | 0.243 | 1.000 | 0.000 | 0.009 | 0.000 | -0.031 | -0.028 | -0.009 |
| required_car_parking_spaces | 0.000 | 0.000 | 0.006 | 0.014 | 0.011 | 0.030 | 0.079 | 0.016 | 0.011 | 0.013 | 0.026 | 0.047 | 0.034 | 0.072 | 0.218 | 0.186 | 0.073 | 0.041 | 0.075 | 0.039 | 0.016 | 0.000 | 1.000 | 0.131 | 0.068 | 0.019 | 0.023 | 0.025 |
| reservation_status | 0.003 | 0.013 | 0.010 | 0.069 | 0.062 | 0.066 | 0.067 | 0.014 | 0.022 | 0.053 | 0.090 | 0.010 | 0.119 | 0.113 | 0.073 | 1.000 | 0.091 | 0.126 | 0.162 | 0.046 | 0.026 | 0.009 | 0.131 | 1.000 | 0.043 | 0.039 | 0.046 | 0.093 |
| reserved_room_type | 0.000 | 0.000 | 0.008 | 0.047 | 0.044 | 0.062 | 0.778 | 0.036 | 0.010 | 0.385 | 0.092 | 0.015 | 0.048 | 0.100 | 0.311 | 0.057 | 0.059 | 0.036 | 0.102 | 0.135 | 0.008 | 0.000 | 0.068 | 0.043 | 1.000 | 0.040 | 0.047 | 0.045 |
| stays_in_week_nights | 0.085 | 0.173 | -0.017 | 0.039 | 0.041 | 0.023 | 0.043 | 0.000 | 0.052 | 0.045 | 0.087 | 0.006 | 0.012 | 0.013 | 0.182 | 0.045 | 0.024 | 0.418 | 0.045 | 0.058 | -0.139 | -0.031 | 0.019 | 0.039 | 0.040 | 1.000 | 0.327 | 0.056 |
| stays_in_weekend_nights | 0.048 | 0.132 | -0.009 | 0.049 | 0.037 | 0.021 | 0.045 | 0.006 | 0.022 | 0.036 | 0.100 | -0.038 | 0.019 | 0.069 | 0.184 | 0.059 | 0.103 | 0.295 | 0.079 | 0.081 | -0.113 | -0.028 | 0.023 | 0.046 | 0.047 | 0.327 | 1.000 | 0.036 |
| total_of_special_requests | 0.162 | 0.159 | -0.003 | 0.043 | 0.044 | 0.057 | 0.033 | 0.059 | -0.005 | 0.056 | 0.076 | -0.070 | 0.077 | 0.097 | 0.022 | 0.131 | 0.046 | 0.063 | 0.163 | 0.039 | -0.004 | -0.009 | 0.025 | 0.093 | 0.045 | 0.056 | 0.036 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | agent | company | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Resort Hotel | 0 | 342 | 2015 | July | 27 | 1 | 0 | 0 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 3 | No Deposit | NULL | NULL | 0 | Transient | 0.0 | 0 | 0 | Check-Out | 2015-07-01 |
| 1 | Resort Hotel | 0 | 737 | 2015 | July | 27 | 1 | 0 | 0 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 4 | No Deposit | NULL | NULL | 0 | Transient | 0.0 | 0 | 0 | Check-Out | 2015-07-01 |
| 2 | Resort Hotel | 0 | 7 | 2015 | July | 27 | 1 | 0 | 1 | 1 | 0.0 | 0 | BB | GBR | Direct | Direct | 0 | 0 | 0 | A | C | 0 | No Deposit | NULL | NULL | 0 | Transient | 75.0 | 0 | 0 | Check-Out | 2015-07-02 |
| 3 | Resort Hotel | 0 | 13 | 2015 | July | 27 | 1 | 0 | 1 | 1 | 0.0 | 0 | BB | GBR | Corporate | Corporate | 0 | 0 | 0 | A | A | 0 | No Deposit | 304 | NULL | 0 | Transient | 75.0 | 0 | 0 | Check-Out | 2015-07-02 |
| 4 | Resort Hotel | 0 | 14 | 2015 | July | 27 | 1 | 0 | 2 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 240 | NULL | 0 | Transient | 98.0 | 0 | 1 | Check-Out | 2015-07-03 |
| 5 | Resort Hotel | 0 | 0 | 2015 | July | 27 | 1 | 0 | 2 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 0 | No Deposit | NULL | NULL | 0 | Transient | 107.0 | 0 | 0 | Check-Out | 2015-07-03 |
| 6 | Resort Hotel | 0 | 9 | 2015 | July | 27 | 1 | 0 | 2 | 2 | 0.0 | 0 | FB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 0 | No Deposit | 303 | NULL | 0 | Transient | 103.0 | 0 | 1 | Check-Out | 2015-07-03 |
| 7 | Resort Hotel | 1 | 85 | 2015 | July | 27 | 1 | 0 | 3 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 240 | NULL | 0 | Transient | 82.0 | 0 | 1 | Canceled | 2015-05-06 |
| 8 | Resort Hotel | 1 | 75 | 2015 | July | 27 | 1 | 0 | 3 | 2 | 0.0 | 0 | HB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 15 | NULL | 0 | Transient | 105.5 | 0 | 0 | Canceled | 2015-04-22 |
| 9 | Resort Hotel | 1 | 23 | 2015 | July | 27 | 1 | 0 | 4 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | E | E | 0 | No Deposit | 240 | NULL | 0 | Transient | 123.0 | 0 | 0 | Canceled | 2015-06-23 |
| hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | agent | company | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87386 | City Hotel | 0 | 44 | 2017 | August | 35 | 31 | 1 | 3 | 2 | 0.0 | 0 | SC | DEU | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9 | NULL | 0 | Transient | 140.75 | 0 | 1 | Check-Out | 2017-09-04 |
| 87387 | City Hotel | 0 | 188 | 2017 | August | 35 | 31 | 2 | 3 | 2 | 0.0 | 0 | BB | DEU | Direct | Direct | 0 | 0 | 0 | A | A | 0 | No Deposit | 14 | NULL | 0 | Transient | 99.00 | 0 | 0 | Check-Out | 2017-09-05 |
| 87388 | City Hotel | 0 | 135 | 2017 | August | 35 | 30 | 2 | 4 | 3 | 0.0 | 0 | BB | JPN | Online TA | TA/TO | 0 | 0 | 0 | G | G | 0 | No Deposit | 7 | NULL | 0 | Transient | 209.00 | 0 | 0 | Check-Out | 2017-09-05 |
| 87389 | City Hotel | 0 | 164 | 2017 | August | 35 | 31 | 2 | 4 | 2 | 0.0 | 0 | BB | DEU | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 42 | NULL | 0 | Transient | 87.60 | 0 | 0 | Check-Out | 2017-09-06 |
| 87390 | City Hotel | 0 | 21 | 2017 | August | 35 | 30 | 2 | 5 | 2 | 0.0 | 0 | BB | BEL | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 394 | NULL | 0 | Transient | 96.14 | 0 | 2 | Check-Out | 2017-09-06 |
| 87391 | City Hotel | 0 | 23 | 2017 | August | 35 | 30 | 2 | 5 | 2 | 0.0 | 0 | BB | BEL | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 394 | NULL | 0 | Transient | 96.14 | 0 | 0 | Check-Out | 2017-09-06 |
| 87392 | City Hotel | 0 | 102 | 2017 | August | 35 | 31 | 2 | 5 | 3 | 0.0 | 0 | BB | FRA | Online TA | TA/TO | 0 | 0 | 0 | E | E | 0 | No Deposit | 9 | NULL | 0 | Transient | 225.43 | 0 | 2 | Check-Out | 2017-09-07 |
| 87393 | City Hotel | 0 | 34 | 2017 | August | 35 | 31 | 2 | 5 | 2 | 0.0 | 0 | BB | DEU | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 9 | NULL | 0 | Transient | 157.71 | 0 | 4 | Check-Out | 2017-09-07 |
| 87394 | City Hotel | 0 | 109 | 2017 | August | 35 | 31 | 2 | 5 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 89 | NULL | 0 | Transient | 104.40 | 0 | 0 | Check-Out | 2017-09-07 |
| 87395 | City Hotel | 0 | 205 | 2017 | August | 35 | 29 | 2 | 7 | 2 | 0.0 | 0 | HB | DEU | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9 | NULL | 0 | Transient | 151.20 | 0 | 2 | Check-Out | 2017-09-07 |